YData Profiling Report

Brought to you by YData

Dataset statistics

Number of variables	15
Number of observations	1628258
Missing cells	103746
Missing cells (%)	0.4%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	352.7 MiB
Average record size in memory	227.2 B

Variable types

Numeric	10
Categorical	4
Text	1

Alerts

`eval_set` has constant value "prior"	Constant
`aisle` has a high cardinality: 134 distinct values	High cardinality
`department` is highly overall correlated with `department_id`	High correlation
`department_id` is highly overall correlated with `department`	High correlation
`days_since_prior_order` has 103746 (6.4%) missing values	Missing
`order_dow` has 309011 (19.0%) zeros	Zeros
`days_since_prior_order` has 21367 (1.3%) zeros	Zeros

Reproduction

Analysis started	2025-10-12 18:18:59.028778
Analysis finished	2025-10-12 18:20:15.914954
Duration	1 minute and 16.89 seconds
Software version	ydata-profiling vv4.17.0
Download configuration	config.json

order_id
Real number (ℝ)

Distinct	161752
Distinct (%)	9.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1711654.8

Minimum	28
Maximum	3421083
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	24.8 MiB

Quantile statistics

Minimum	28
5-th percentile	167144
Q1	861420
median	1711303
Q3	2570465
95-th percentile	3249603
Maximum	3421083
Range	3421055
Interquartile range (IQR)	1709045

Descriptive statistics

Standard deviation	987490.76
Coefficient of variation (CV)	0.57692168
Kurtosis	-1.1994225
Mean	1711654.8
Median Absolute Deviation (MAD)	854109
Skewness	-0.0036100055
Sum	2.7870156 × 10¹²
Variance	9.75138 × 10¹¹
Monotonicity	Increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
3065077	86	< 0.1%
2621428	76	< 0.1%
521291	72	< 0.1%
2640800	71	< 0.1%
2877090	70	< 0.1%
1477139	68	< 0.1%
1723549	67	< 0.1%
1007609	64	< 0.1%
3205600	63	< 0.1%
3097933	63	< 0.1%
Other values (161742)	1627558	> 99.9%

Value	Count	Frequency (%)
28	16	< 0.1%
48	8	< 0.1%
54	7	< 0.1%
67	8	< 0.1%
71	10	< 0.1%
109	21	< 0.1%
122	2	< 0.1%
138	6	< 0.1%
151	4	< 0.1%
156	5	< 0.1%

Value	Count	Frequency (%)
3421083	10	< 0.1%
3421080	9	< 0.1%
3421066	6	< 0.1%
3420988	8	< 0.1%
3420968	10	< 0.1%
3420938	12	< 0.1%
3420918	15	< 0.1%
3420908	6	< 0.1%
3420901	12	< 0.1%
3420897	10	< 0.1%

product_id
Real number (ℝ)

Distinct	35600
Distinct (%)	2.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	25645.597

Minimum	1
Maximum	49688
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	24.8 MiB

Quantile statistics

Minimum	1
5-th percentile	3399
Q1	13598
median	25464
Q3	38100
95-th percentile	47601
Maximum	49688
Range	49687
Interquartile range (IQR)	24502

Descriptive statistics

Standard deviation	14092.605
Coefficient of variation (CV)	0.54951364
Kurtosis	-1.140182
Mean	25645.597
Median Absolute Deviation (MAD)	12215
Skewness	-0.026094877
Sum	4.1757649 × 10¹⁰
Variance	1.9860153 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
24852	23082	1.4%
13176	19056	1.2%
21137	13445	0.8%
21903	12152	0.7%
47209	10874	0.7%
47766	9073	0.6%
47626	7616	0.5%
26209	7349	0.5%
27845	7197	0.4%
16797	7075	0.4%
Other values (35590)	1511339	92.8%

Value	Count	Frequency (%)
1	71	< 0.1%
2	2	< 0.1%
3	6	< 0.1%
4	13	< 0.1%
5	2	< 0.1%
8	1	< 0.1%
9	8	< 0.1%
10	134	< 0.1%
11	8	< 0.1%
12	12	< 0.1%

Value	Count	Frequency (%)
49688	2	< 0.1%
49686	2	< 0.1%
49685	6	< 0.1%
49683	5192	0.3%
49682	1	< 0.1%
49680	62	< 0.1%
49679	5	< 0.1%
49678	10	< 0.1%
49677	9	< 0.1%
49676	4	< 0.1%

add_to_cart_order
Real number (ℝ)

Distinct	86
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	8.2750479

Minimum	1
Maximum	86
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	24.8 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	3
median	6
Q3	11
95-th percentile	22
Maximum	86
Range	85
Interquartile range (IQR)	8

Descriptive statistics

Standard deviation	6.9281293
Coefficient of variation (CV)	0.83723131
Kurtosis	3.6996824
Mean	8.2750479
Median Absolute Deviation (MAD)	4
Skewness	1.6209974
Sum	13473913
Variance	47.998975
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	161752	9.9%
2	153881	9.5%
3	144405	8.9%
4	133991	8.2%
5	123003	7.6%
6	111455	6.8%
7	99893	6.1%
8	88888	5.5%
9	78593	4.8%
10	69340	4.3%
Other values (76)	463057	28.4%

Value	Count	Frequency (%)
1	161752	9.9%
2	153881	9.5%
3	144405	8.9%
4	133991	8.2%
5	123003	7.6%
6	111455	6.8%
7	99893	6.1%
8	88888	5.5%
9	78593	4.8%
10	69340	4.3%

Value	Count	Frequency (%)
86	1	< 0.1%
85	1	< 0.1%
84	1	< 0.1%
83	1	< 0.1%
82	1	< 0.1%
81	1	< 0.1%
80	1	< 0.1%
79	1	< 0.1%
78	1	< 0.1%
77	1	< 0.1%

reordered
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	90.1 MiB

1	958236
0	670022

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	1628258
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	1
3rd row	0
4th row	1
5th row	1

Common Values

Value	Count	Frequency (%)
1	958236	58.9%
0	670022	41.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	958236	58.9%
0	670022	41.1%

Most occurring characters

Value	Count	Frequency (%)
1	958236	58.9%
0	670022	41.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1628258	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	958236	58.9%
0	670022	41.1%

Most occurring scripts

Value	Count	Frequency (%)
Common	1628258	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	958236	58.9%
0	670022	41.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1628258	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	958236	58.9%
0	670022	41.1%

product_name
Text

Distinct	35600
Distinct (%)	2.2%
Missing	0
Missing (%)	0.0%
Memory size	127.6 MiB

Length

Max length	159
Median length	120
Mean length	24.95476
Min length	3

Characters and Unicode

Total characters	40632787
Distinct characters	105
Distinct categories	14 ?
Distinct scripts	3 ?
Distinct blocks	7 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	6761 ?
Unique (%)	0.4%

Sample

1st row	Salted Butter
2nd row	Cream Cheese
3rd row	Air Chilled Organic Boneless Skinless Chicken Breasts
4th row	Organic D'Anjou Pears
5th row	Cultured Low Fat Buttermilk

Value	Count	Frequency (%)
organic	518491	8.4%
	100020	1.6%
milk	86989	1.4%
cheese	71582	1.2%
yogurt	66273	1.1%
whole	62735	1.0%
free	58486	0.9%
water	50567	0.8%
baby	49910	0.8%
original	48536	0.8%
Other values (9606)	5070524	82.0%

Most occurring characters

Value	Count	Frequency (%)
	4564521	11.2%
e	3814750	9.4%
a	3465999	8.5%
r	2868253	7.1%
i	2403362	5.9%
n	2229947	5.5%
o	1783377	4.4%
l	1679957	4.1%
t	1670456	4.1%
s	1355246	3.3%
Other values (95)	14796919	36.4%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	29544165	72.7%
Uppercase Letter	5997347	14.8%
Space Separator	4564798	11.2%
Other Punctuation	266245	0.7%
Decimal Number	190364	0.5%
Dash Punctuation	47240	0.1%
Close Punctuation	7826	< 0.1%
Open Punctuation	7826	< 0.1%
Math Symbol	3720	< 0.1%
Other Symbol	3194	< 0.1%
Other values (4)	62	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	3814750	12.9%
a	3465999	11.7%
r	2868253	9.7%
i	2403362	8.1%
n	2229947	7.5%
o	1783377	6.0%
l	1679957	5.7%
t	1670456	5.7%
s	1355246	4.6%
c	1318540	4.5%
Other values (26)	6954278	23.5%

Uppercase Letter

Value	Count	Frequency (%)
C	731615	12.2%
O	684910	11.4%
S	677128	11.3%
B	615469	10.3%
P	379916	6.3%
F	297783	5.0%
M	288947	4.8%
G	282360	4.7%
A	243320	4.1%
R	237773	4.0%
Other values (16)	1558126	26.0%

Other Punctuation

Value	Count	Frequency (%)
&	93682	35.2%
,	70277	26.4%
%	63226	23.7%
'	15156	5.7%
/	9318	3.5%
!	4733	1.8%
.	4565	1.7%
:	1909	0.7%
\	1353	0.5%
"	1353	0.5%
Other values (5)	673	0.3%

Decimal Number

Value	Count	Frequency (%)
0	66384	34.9%
1	42352	22.2%
2	36411	19.1%
3	12944	6.8%
4	7963	4.2%
5	7632	4.0%
9	5711	3.0%
8	4173	2.2%
7	3453	1.8%
6	3341	1.8%

Other Symbol

Value	Count	Frequency (%)
®	1966	61.6%
™	1223	38.3%
�	4	0.1%
°	1	< 0.1%

Dash Punctuation

Value	Count	Frequency (%)
-	47087	99.7%
‑	145	0.3%
–	8	< 0.1%

Space Separator

Value	Count	Frequency (%)
	4564521	> 99.9%
	277	< 0.1%

Math Symbol

Value	Count	Frequency (%)
+	3505	94.2%
=	215	5.8%

Modifier Symbol

Value	Count	Frequency (%)
˚	4	57.1%
´	3	42.9%

Close Punctuation

Value	Count	Frequency (%)
)	7826	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	7826	100.0%

Currency Symbol

Value	Count	Frequency (%)
$	24	100.0%

Final Punctuation

Value	Count	Frequency (%)
’	19	100.0%

Control

Value	Count	Frequency (%)
	12	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	35541444	87.5%
Common	5091275	12.5%
Cyrillic	68	< 0.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	3814750	10.7%
a	3465999	9.8%
r	2868253	8.1%
i	2403362	6.8%
n	2229947	6.3%
o	1783377	5.0%
l	1679957	4.7%
t	1670456	4.7%
s	1355246	3.8%
c	1318540	3.7%
Other values (51)	12951557	36.4%

Common

Value	Count	Frequency (%)
	4564521	89.7%
&	93682	1.8%
,	70277	1.4%
0	66384	1.3%
%	63226	1.2%
-	47087	0.9%
1	42352	0.8%
2	36411	0.7%
'	15156	0.3%
3	12944	0.3%
Other values (33)	79235	1.6%

Cyrillic

Value	Count	Frequency (%)
е	68	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	40627936	> 99.9%
None	3380	< 0.1%
Letterlike Symbols	1223	< 0.1%
Punctuation	172	< 0.1%
Cyrillic	68	< 0.1%
Modifier Letters	4	< 0.1%
Specials	4	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	4564521	11.2%
e	3814750	9.4%
a	3465999	8.5%
r	2868253	7.1%
i	2403362	5.9%
n	2229947	5.5%
o	1783377	4.4%
l	1679957	4.1%
t	1670456	4.1%
s	1355246	3.3%
Other values (74)	14792068	36.4%

None

Value	Count	Frequency (%)
®	1966	58.2%
é	710	21.0%
	277	8.2%
ñ	246	7.3%
è	92	2.7%
í	48	1.4%
	12	0.4%
ü	8	0.2%
â	6	0.2%
ô	6	0.2%
Other values (4)	9	0.3%

Letterlike Symbols

Value	Count	Frequency (%)
™	1223	100.0%

Punctuation

Value	Count	Frequency (%)
‑	145	84.3%
’	19	11.0%
–	8	4.7%

Cyrillic

Value	Count	Frequency (%)
е	68	100.0%

Modifier Letters

Value	Count	Frequency (%)
˚	4	100.0%

Specials

Value	Count	Frequency (%)
�	4	100.0%

aisle_id
Real number (ℝ)

Distinct	134
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	71.227631

Minimum	1
Maximum	134
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	24.8 MiB

Quantile statistics

Minimum	1
5-th percentile	16
Q1	31
median	83
Q3	107
95-th percentile	123
Maximum	134
Range	133
Interquartile range (IQR)	76

Descriptive statistics

Standard deviation	38.151598
Coefficient of variation (CV)	0.53562918
Kurtosis	-1.3250255
Mean	71.227631
Median Absolute Deviation (MAD)	33
Skewness	-0.16663328
Sum	1.1597696 × 10⁸
Variance	1455.5444
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
24	182972	11.2%
83	173830	10.7%
123	89048	5.5%
120	71129	4.4%
21	48244	3.0%
84	44769	2.7%
115	43346	2.7%
107	35820	2.2%
91	32037	2.0%
112	29796	1.8%
Other values (124)	877267	53.9%

Value	Count	Frequency (%)
1	3331	0.2%
2	4200	0.3%
3	21859	1.3%
4	9632	0.6%
5	3159	0.2%
6	1939	0.1%
7	1640	0.1%
8	1749	0.1%
9	11078	0.7%
10	429	< 0.1%

Value	Count	Frequency (%)
134	550	< 0.1%
133	975	0.1%
132	344	< 0.1%
131	13589	0.8%
130	7931	0.5%
129	9163	0.6%
128	9792	0.6%
127	1956	0.1%
126	946	0.1%
125	1722	0.1%

department_id
Real number (ℝ)

High correlation

Distinct	21
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	9.8816557

Minimum	1
Maximum	21
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	24.8 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	4
median	9
Q3	16
95-th percentile	19
Maximum	21
Range	20
Interquartile range (IQR)	12

Descriptive statistics

Standard deviation	6.2720808
Coefficient of variation (CV)	0.63471963
Kurtosis	-1.556463
Mean	9.8816557
Median Absolute Deviation (MAD)	5
Skewness	0.15978088
Sum	16089885
Variance	39.338998
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=21)

Value	Count	Frequency (%)
4	479501	29.4%
16	270170	16.6%
19	141984	8.7%
7	133421	8.2%
1	112718	6.9%
13	95048	5.8%
3	59411	3.6%
15	53922	3.3%
20	52533	3.2%
9	43511	2.7%
Other values (11)	186039	11.4%

Value	Count	Frequency (%)
1	112718	6.9%
2	1939	0.1%
3	59411	3.6%
4	479501	29.4%
5	7448	0.5%
6	14351	0.9%
7	133421	8.2%
8	5104	0.3%
9	43511	2.7%
10	1530	0.1%

Value	Count	Frequency (%)
21	3435	0.2%
20	52533	3.2%
19	141984	8.7%
18	20834	1.3%
17	36529	2.2%
16	270170	16.6%
15	53922	3.3%
14	36173	2.2%
13	95048	5.8%
12	36280	2.2%

aisle
Categorical

High cardinality

Distinct	134
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	15.5 MiB

fresh fruits	182972
fresh vegetables	173830
packaged vegetables fruits	89048
yogurt	71129
packaged cheese	48244
Other values (129)	1063035

Length

Max length	29
Median length	23
Mean length	14.451632
Min length	3

Characters and Unicode

Total characters	23530985
Distinct characters	26
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	butter
2nd row	other creams cheeses
3rd row	poultry counter
4th row	fresh fruits
5th row	milk

Common Values

Value	Count	Frequency (%)
fresh fruits	182972	11.2%
fresh vegetables	173830	10.7%
packaged vegetables fruits	89048	5.5%
yogurt	71129	4.4%
packaged cheese	48244	3.0%
milk	44769	2.7%
water seltzer sparkling water	43346	2.7%
chips pretzels	35820	2.2%
soy lactosefree	32037	2.0%
bread	29796	1.8%
Other values (124)	877267	53.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
fresh	396104	11.4%
vegetables	278597	8.0%
fruits	272837	7.9%
packaged	160237	4.6%
frozen	88137	2.5%
water	86692	2.5%
yogurt	71129	2.1%
ice	49715	1.4%
cheese	48244	1.4%
milk	44769	1.3%
Other values (194)	1964439	56.8%

Most occurring characters

Value	Count	Frequency (%)
e	3369157	14.3%
s	2230435	9.5%
r	1993943	8.5%
a	1848210	7.9%
	1832642	7.8%
t	1383598	5.9%
f	1014726	4.3%
i	938425	4.0%
o	885014	3.8%
g	877805	3.7%
Other values (16)	7157030	30.4%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	21698343	92.2%
Space Separator	1832642	7.8%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	3369157	15.5%
s	2230435	10.3%
r	1993943	9.2%
a	1848210	8.5%
t	1383598	6.4%
f	1014726	4.7%
i	938425	4.3%
o	885014	4.1%
g	877805	4.0%
c	836378	3.9%
Other values (15)	6320652	29.1%

Space Separator

Value	Count	Frequency (%)
	1832642	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	21698343	92.2%
Common	1832642	7.8%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	3369157	15.5%
s	2230435	10.3%
r	1993943	9.2%
a	1848210	8.5%
t	1383598	6.4%
f	1014726	4.7%
i	938425	4.3%
o	885014	4.1%
g	877805	4.0%
c	836378	3.9%
Other values (15)	6320652	29.1%

Common

Value	Count	Frequency (%)
	1832642	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	23530985	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	3369157	14.3%
s	2230435	9.5%
r	1993943	8.5%
a	1848210	7.9%
	1832642	7.8%
t	1383598	5.9%
f	1014726	4.3%
i	938425	4.0%
o	885014	3.8%
g	877805	3.7%
Other values (16)	7157030	30.4%

department
Categorical

High correlation

Distinct	21
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	14.0 MiB

produce	479501
dairy eggs	270170
snacks	141984
beverages	133421
frozen	112718
Other values (16)	490464

Length

Max length	15
Median length	13
Mean length	8.0017344
Min length	4

Characters and Unicode

Total characters	13028888
Distinct characters	23
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	dairy eggs
2nd row	dairy eggs
3rd row	meat seafood
4th row	produce
5th row	dairy eggs

Common Values

Value	Count	Frequency (%)
produce	479501	29.4%
dairy eggs	270170	16.6%
snacks	141984	8.7%
beverages	133421	8.2%
frozen	112718	6.9%
pantry	95048	5.8%
bakery	59411	3.6%
canned goods	53922	3.3%
deli	52533	3.2%
dry goods pasta	43511	2.7%
Other values (11)	186039	11.4%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
produce	479501	22.9%
dairy	270170	12.9%
eggs	270170	12.9%
snacks	141984	6.8%
beverages	133421	6.4%
frozen	112718	5.4%
goods	97433	4.6%
pantry	95048	4.5%
bakery	59411	2.8%
canned	53922	2.6%
Other values (16)	384290	18.3%

Most occurring characters

Value	Count	Frequency (%)
e	1660840	12.7%
r	1291075	9.9%
a	1087700	8.3%
d	1069879	8.2%
s	992709	7.6%
o	986305	7.6%
g	774629	5.9%
c	705271	5.4%
p	645580	5.0%
n	526498	4.0%
Other values (13)	3288402	25.2%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	12559078	96.4%
Space Separator	469810	3.6%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	1660840	13.2%
r	1291075	10.3%
a	1087700	8.7%
d	1069879	8.5%
s	992709	7.9%
o	986305	7.9%
g	774629	6.2%
c	705271	5.6%
p	645580	5.1%
n	526498	4.2%
Other values (12)	2818592	22.4%

Space Separator

Value	Count	Frequency (%)
	469810	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	12559078	96.4%
Common	469810	3.6%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	1660840	13.2%
r	1291075	10.3%
a	1087700	8.7%
d	1069879	8.5%
s	992709	7.9%
o	986305	7.9%
g	774629	6.2%
c	705271	5.6%
p	645580	5.1%
n	526498	4.2%
Other values (12)	2818592	22.4%

Common

Value	Count	Frequency (%)
	469810	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	13028888	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	1660840	12.7%
r	1291075	9.9%
a	1087700	8.3%
d	1069879	8.2%
s	992709	7.6%
o	986305	7.6%
g	774629	5.9%
c	705271	5.4%
p	645580	5.0%
n	526498	4.0%
Other values (13)	3288402	25.2%

user_id
Real number (ℝ)

Distinct	10310
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	103260.41

Minimum	5
Maximum	206186
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	24.8 MiB

Quantile statistics

Minimum	5
5-th percentile	11859
Q1	52889
median	101343
Q3	155002
95-th percentile	195555
Maximum	206186
Range	206181
Interquartile range (IQR)	102113

Descriptive statistics

Standard deviation	59044.277
Coefficient of variation (CV)	0.57179977
Kurtosis	-1.1996034
Mean	103260.41
Median Absolute Deviation (MAD)	51022
Skewness	0.021337609
Sum	1.6813458 × 10¹¹
Variance	3.4862266 × 10⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
182401	2907	0.2%
147480	2004	0.1%
95967	1992	0.1%
132022	1920	0.1%
151378	1886	0.1%
171771	1862	0.1%
146770	1809	0.1%
29041	1776	0.1%
13131	1600	0.1%
53928	1587	0.1%
Other values (10300)	1608915	98.8%

Value	Count	Frequency (%)
5	37	< 0.1%
7	206	< 0.1%
13	81	< 0.1%
34	32	< 0.1%
71	437	< 0.1%
102	59	< 0.1%
106	41	< 0.1%
118	165	< 0.1%
124	79	< 0.1%
129	64	< 0.1%

Value	Count	Frequency (%)
206186	32	< 0.1%
206165	559	< 0.1%
206138	117	< 0.1%
206133	21	< 0.1%
206126	524	< 0.1%
206084	110	< 0.1%
206076	18	< 0.1%
206054	156	< 0.1%
206044	158	< 0.1%
206043	361	< 0.1%

eval_set
Categorical

Constant

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	96.3 MiB

prior	1628258

Length

Max length	5
Median length	5
Mean length	5
Min length	5

Characters and Unicode

Total characters	8141290
Distinct characters	4
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	prior
2nd row	prior
3rd row	prior
4th row	prior
5th row	prior

Common Values

Value	Count	Frequency (%)
prior	1628258	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
prior	1628258	100.0%

Most occurring characters

Value	Count	Frequency (%)
r	3256516	40.0%
p	1628258	20.0%
i	1628258	20.0%
o	1628258	20.0%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	8141290	100.0%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
r	3256516	40.0%
p	1628258	20.0%
i	1628258	20.0%
o	1628258	20.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	8141290	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
r	3256516	40.0%
p	1628258	20.0%
i	1628258	20.0%
o	1628258	20.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	8141290	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
r	3256516	40.0%
p	1628258	20.0%
i	1628258	20.0%
o	1628258	20.0%

order_number
Real number (ℝ)

Distinct	99
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	17.261568

Minimum	1
Maximum	99
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	24.8 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	5
median	11
Q3	24
95-th percentile	55
Maximum	99
Range	98
Interquartile range (IQR)	19

Descriptive statistics

Standard deviation	17.698826
Coefficient of variation (CV)	1.0253313
Kurtosis	3.2365932
Mean	17.261568
Median Absolute Deviation (MAD)	8
Skewness	1.7618986
Sum	28106287
Variance	313.24844
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	103746	6.4%
3	102230	6.3%
2	102105	6.3%
4	90874	5.6%
5	81424	5.0%
6	73836	4.5%
7	66540	4.1%
8	60463	3.7%
9	55667	3.4%
10	52192	3.2%
Other values (89)	839181	51.5%

Value	Count	Frequency (%)
1	103746	6.4%
2	102105	6.3%
3	102230	6.3%
4	90874	5.6%
5	81424	5.0%
6	73836	4.5%
7	66540	4.1%
8	60463	3.7%
9	55667	3.4%
10	52192	3.2%

Value	Count	Frequency (%)
99	584	< 0.1%
98	623	< 0.1%
97	681	< 0.1%
96	794	< 0.1%
95	686	< 0.1%
94	795	< 0.1%
93	892	0.1%
92	849	0.1%
91	817	0.1%
90	909	0.1%

order_dow
Real number (ℝ)

Zeros

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.7427361

Minimum	0
Maximum	6
Zeros	309011
Zeros (%)	19.0%
Negative	0
Negative (%)	0.0%
Memory size	24.8 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	3
Q3	5
95-th percentile	6
Maximum	6
Range	6
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	2.0874903
Coefficient of variation (CV)	0.76109775
Kurtosis	-1.3349633
Mean	2.7427361
Median Absolute Deviation (MAD)	2
Skewness	0.17624328
Sum	4465882
Variance	4.3576157
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
0	309011	19.0%
1	287284	17.6%
6	224543	13.8%
5	212734	13.1%
2	208707	12.8%
3	193660	11.9%
4	192319	11.8%

Value	Count	Frequency (%)
0	309011	19.0%
1	287284	17.6%
2	208707	12.8%
3	193660	11.9%
4	192319	11.8%
5	212734	13.1%
6	224543	13.8%

Value	Count	Frequency (%)
6	224543	13.8%
5	212734	13.1%
4	192319	11.8%
3	193660	11.9%
2	208707	12.8%
1	287284	17.6%
0	309011	19.0%

order_hour_of_day
Real number (ℝ)

Distinct	24
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	13.412536

Minimum	0
Maximum	23
Zeros	11147
Zeros (%)	0.7%
Negative	0
Negative (%)	0.0%
Memory size	24.8 MiB

Quantile statistics

Minimum	0
5-th percentile	7
Q1	10
median	13
Q3	16
95-th percentile	21
Maximum	23
Range	23
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	4.2421835
Coefficient of variation (CV)	0.31628497
Kurtosis	0.0033815488
Mean	13.412536
Median Absolute Deviation (MAD)	3
Skewness	-0.041912801
Sum	21839069
Variance	17.996121
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=24)

Value	Count	Frequency (%)
11	140977	8.7%
10	140359	8.6%
14	137369	8.4%
15	133199	8.2%
13	132740	8.2%
12	132071	8.1%
16	125882	7.7%
9	122260	7.5%
17	103512	6.4%
8	84685	5.2%
Other values (14)	375204	23.0%

Value	Count	Frequency (%)
0	11147	0.7%
1	5762	0.4%
2	3755	0.2%
3	2530	0.2%
4	2362	0.1%
5	4718	0.3%
6	14574	0.9%
7	44939	2.8%
8	84685	5.2%
9	122260	7.5%

Value	Count	Frequency (%)
23	19740	1.2%
22	32215	2.0%
21	39597	2.4%
20	49280	3.0%
19	63139	3.9%
18	81446	5.0%
17	103512	6.4%
16	125882	7.7%
15	133199	8.2%
14	137369	8.4%

days_since_prior_order
Real number (ℝ)

Missing Zeros

Distinct	31
Distinct (%)	< 0.1%
Missing	103746
Missing (%)	6.4%
Infinite	0
Infinite (%)	0.0%
Mean	11.077978

Minimum	0
Maximum	30
Zeros	21367
Zeros (%)	1.3%
Negative	0
Negative (%)	0.0%
Memory size	24.8 MiB

Quantile statistics

Minimum	0
5-th percentile	2
Q1	5
median	8
Q3	15
95-th percentile	30
Maximum	30
Range	30
Interquartile range (IQR)	10

Descriptive statistics

Standard deviation	8.769521
Coefficient of variation (CV)	0.79161745
Kurtosis	-0.058519759
Mean	11.077978
Median Absolute Deviation (MAD)	4
Skewness	1.0561316
Sum	16888511
Variance	76.904498
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=31)

Value	Count	Frequency (%)
7	170442	10.5%
30	153514	9.4%
6	125498	7.7%
5	107719	6.6%
4	106087	6.5%
3	95801	5.9%
8	95159	5.8%
2	75652	4.6%
9	60567	3.7%
14	51153	3.1%
Other values (21)	482920	29.7%
(Missing)	103746	6.4%

Value	Count	Frequency (%)
0	21367	1.3%
1	48220	3.0%
2	75652	4.6%
3	95801	5.9%
4	106087	6.5%
5	107719	6.6%
6	125498	7.7%
7	170442	10.5%
8	95159	5.8%
9	60567	3.7%

Value	Count	Frequency (%)
30	153514	9.4%
29	8702	0.5%
28	12606	0.8%
27	9750	0.6%
26	8805	0.5%
25	9091	0.6%
24	9811	0.6%
23	10895	0.7%
22	15874	1.0%
21	22129	1.4%

	add_to_cart_order	aisle_id	days_since_prior_order	department	department_id	order_dow	order_hour_of_day	order_id	order_number	product_id	reordered	user_id
add_to_cart_order	1.000	0.003	0.080	0.039	0.009	-0.012	-0.019	-0.000	-0.002	0.008	0.128	0.011
aisle_id	0.003	1.000	0.004	0.439	0.024	-0.001	-0.003	0.000	0.006	0.006	0.088	0.001
days_since_prior_order	0.080	0.004	1.000	0.019	0.001	-0.041	-0.007	-0.003	-0.384	-0.002	0.137	0.016
department	0.039	0.439	0.019	1.000	1.000	0.024	0.015	0.003	0.018	0.075	0.198	0.018
department_id	0.009	0.024	0.001	1.000	1.000	0.008	-0.010	0.001	0.002	-0.023	0.159	0.001
order_dow	-0.012	-0.001	-0.041	0.024	0.008	1.000	0.007	-0.001	0.010	-0.002	0.016	-0.009
order_hour_of_day	-0.019	-0.003	-0.007	0.015	-0.010	0.007	1.000	0.001	-0.040	-0.000	0.036	0.007
order_id	-0.000	0.000	-0.003	0.003	0.001	-0.001	0.001	1.000	0.002	0.000	0.003	-0.001
order_number	-0.002	0.006	-0.384	0.018	0.002	0.010	-0.040	0.002	1.000	0.003	0.342	-0.012
product_id	0.008	0.006	-0.002	0.075	-0.023	-0.002	-0.000	0.000	0.003	1.000	0.040	-0.002
reordered	0.128	0.088	0.137	0.198	0.159	0.016	0.036	0.003	0.342	0.040	1.000	0.017
user_id	0.011	0.001	0.016	0.018	0.001	-0.009	0.007	-0.001	-0.012	-0.002	0.017	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

	order_id	product_id	add_to_cart_order	reordered	product_name	aisle_id	department_id	aisle	department	user_id	eval_set	order_number	order_dow	order_hour_of_day	days_since_prior_order
268	28	35108	1	0	Salted Butter	36	16	butter	dairy eggs	98256	prior	29	3	13	6.0
269	28	40593	2	1	Cream Cheese	108	16	other creams cheeses	dairy eggs	98256	prior	29	3	13	6.0
270	28	17461	3	0	Air Chilled Organic Boneless Skinless Chicken Breasts	35	12	poultry counter	meat seafood	98256	prior	29	3	13	6.0
271	28	22825	4	1	Organic D'Anjou Pears	24	4	fresh fruits	produce	98256	prior	29	3	13	6.0
272	28	25256	5	1	Cultured Low Fat Buttermilk	84	16	milk	dairy eggs	98256	prior	29	3	13	6.0
273	28	47626	6	1	Large Lemon	24	4	fresh fruits	produce	98256	prior	29	3	13	6.0
274	28	37220	7	1	Organic Strawberry Fruit Spread	88	13	spreads	pantry	98256	prior	29	3	13	6.0
275	28	12980	8	1	Large Greenhouse Tomato	83	4	fresh vegetables	produce	98256	prior	29	3	13	6.0
276	28	27548	9	1	Original Semisoft Cheese	21	16	packaged cheese	dairy eggs	98256	prior	29	3	13	6.0
277	28	45504	10	1	Whole Organic Omega 3 Milk	84	16	milk	dairy eggs	98256	prior	29	3	13	6.0

	order_id	product_id	add_to_cart_order	reordered	product_name	aisle_id	department_id	aisle	department	user_id	eval_set	order_number	order_dow	order_hour_of_day	days_since_prior_order
32434479	3421083	7854	1	0	Freeze Dried Mango Slices	117	19	nuts seeds dried fruit	snacks	25247	prior	24	2	6	21.0
32434480	3421083	45309	2	0	Purple Carrot & blueberry Puffs	92	18	baby food formula	babies	25247	prior	24	2	6	21.0
32434481	3421083	21162	3	0	Organic Mixed Berry Yogurt & Fruit Snack	92	18	baby food formula	babies	25247	prior	24	2	6	21.0
32434482	3421083	18176	4	1	Organic Strawberry Yogurt & Fruit Snack	92	18	baby food formula	babies	25247	prior	24	2	6	21.0
32434483	3421083	35211	5	0	Organic Strawberry & Mango Dried Tiny Fruits	92	18	baby food formula	babies	25247	prior	24	2	6	21.0
32434484	3421083	39678	6	1	Free & Clear Natural Dishwasher Detergent	74	17	dish detergents	household	25247	prior	24	2	6	21.0
32434485	3421083	11352	7	0	Organic Mini Sandwich Crackers Peanut Butter	78	19	crackers	snacks	25247	prior	24	2	6	21.0
32434486	3421083	4600	8	0	All Natural French Toast Sticks	52	1	frozen breakfast	frozen	25247	prior	24	2	6	21.0
32434487	3421083	24852	9	1	Banana	24	4	fresh fruits	produce	25247	prior	24	2	6	21.0
32434488	3421083	5020	10	1	Organic Sweet & Salty Peanut Pretzel Granola Bars	3	19	energy granola bars	snacks	25247	prior	24	2	6	21.0

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Other Punctuation

Decimal Number

Other Symbol

Dash Punctuation

Space Separator

Math Symbol

Modifier Symbol

Close Punctuation

Open Punctuation

Currency Symbol

Final Punctuation

Control

Most occurring scripts

Most frequent character per script

Latin

Common

Cyrillic

Most occurring blocks

Most frequent character per block

ASCII

None

Letterlike Symbols

Punctuation

Cyrillic

Modifier Letters

Specials

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category